UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6SGnzsYR0xO/2pLBLXFDUywcb8bUfwHzSWQkbZiO5E='
WHERE
key_id = '7e700af73f6f829562ae884b3a20684dabf124cb34c3f4bef7787467fcc5308c'
AND (
token = 'B6SGnzsYR0xO/2pLBLXFDUywcb8bUfwHzSWQkbZiO5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)