UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOXW94IQApOZaWNC9kEKz/uLkrD8y+9GwVORLVxgBQo='
WHERE
key_id = '53e56a1fef9b8fed420bbd46c61976004a52ab750e5442c941937b9835a16f0d'
AND (
token = 'cOXW94IQApOZaWNC9kEKz/uLkrD8y+9GwVORLVxgBQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)