UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6/7q28ydGqDgqoYLFmBYgabdWIbTMsZkiPZmShLhTo='
WHERE
key_id = '7ffe7c244c5cce430d8b3d091f7bf62a3b99328c52b7be54bd5aefd9bb5608fb'
AND (
token = 'P6/7q28ydGqDgqoYLFmBYgabdWIbTMsZkiPZmShLhTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)