UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lO5r67WJz7pxovWUbSSBMp7jj/aBeUUeJopNj25o808='
WHERE
key_id = 'd2ff4b1b8817542d1151382ed1142846ad7247cb07f2ab69c6f5a0a696cf18d0'
AND (
token = 'lO5r67WJz7pxovWUbSSBMp7jj/aBeUUeJopNj25o808='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)