UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xd3hbyQfDDxmo0+dIERy/r7A5GgO0Sp2hX3b8/wKEs='
WHERE
key_id = '4af77d8037df6094ff47b745310f5d2f2e36be6a4f46ac3f3bf5172aec2a69ac'
AND (
token = '6xd3hbyQfDDxmo0+dIERy/r7A5GgO0Sp2hX3b8/wKEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)