UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VzR34CGtizXq8nld/tX8rpDkBzY6N80sjxzBwZzAzk='
WHERE
key_id = '49266f97dd8bdcaca6fc201fd7f2a27774392fa558774cc2db08f9a8babf7298'
AND (
token = '9VzR34CGtizXq8nld/tX8rpDkBzY6N80sjxzBwZzAzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)