UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ioRaJoig8DeUeVP2jUIwgr8yk3ZTGRbHIEd869MdPFs='
WHERE
key_id = 'd47ae16c3f19caf025be598bc4d9d378124019d20a333b714b24a40991656f94'
AND (
token = 'ioRaJoig8DeUeVP2jUIwgr8yk3ZTGRbHIEd869MdPFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)