UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hD158hbHu/nNHknkNPkop9BepTxOMLlD328Zkt55tEM='
WHERE
key_id = 'ed25b7e4d05d35e3bbb07e89863c97ac08a7d004a02cf1d49d7141700bc33ccf'
AND (
token = 'hD158hbHu/nNHknkNPkop9BepTxOMLlD328Zkt55tEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)