UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j9qix08t9PBZzZl/YBRUxF2qG0BH2E6jn4SAaBXn3ek='
WHERE
key_id = 'a870fc37dbf41b770ef7b30a1043db3ef0c7afc2daf6187e7c0cf2f7680cfe32'
AND (
token = 'j9qix08t9PBZzZl/YBRUxF2qG0BH2E6jn4SAaBXn3ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)