UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BCvfzCN85hMqEMBhxVMgg+6J0UJg6fDOmmd/ZhKROs='
WHERE
key_id = '6ccb72b952ced7a612077b49e5a1c97d50888e6851812a21faaf355991966966'
AND (
token = '8BCvfzCN85hMqEMBhxVMgg+6J0UJg6fDOmmd/ZhKROs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)