UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCdz2r7lNIm7JILZhmNC4iJhIYSNA1fV/TBXcW6dwhA='
WHERE
key_id = '1d840252e781ba4325a1b4166ae57a85c015f7b6eaea798f671168290dc2f052'
AND (
token = 'xCdz2r7lNIm7JILZhmNC4iJhIYSNA1fV/TBXcW6dwhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)