UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5aS0cDLqC3O2CoAaYpkXcet4L8E1TLoPxfithuo9SCQ='
WHERE
key_id = 'c154f5bdc47bca7ea04a4a5024d87b5c714bf8a47037dc35c333f0241dfddba3'
AND (
token = '5aS0cDLqC3O2CoAaYpkXcet4L8E1TLoPxfithuo9SCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)