UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CBlezrJjdRU64iaSUDWIZwi51SPPkU9+J21PeXFxKbM='
WHERE
key_id = '29a8a16e5ee7c1fd764988fd2e3c9be3f165ff42770521f197c9bf5735a5701b'
AND (
token = 'CBlezrJjdRU64iaSUDWIZwi51SPPkU9+J21PeXFxKbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)