UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JouJFlHwdla44oo873+nT2q5lWY616saNR5f8qf3+o8='
WHERE
key_id = '64fa7a253f0f3ba6a50262d612466588a551776c3e39a2b41e1e7eca3d10240a'
AND (
token = 'JouJFlHwdla44oo873+nT2q5lWY616saNR5f8qf3+o8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)