UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ugrd/XMJhg6RO57v6+Yi+iiJnVDhUHr7fJ8f5qBo2Kg='
WHERE
key_id = 'a99d89623bc0a2c5a106a97ee22fadddba90ed9ee6b05d5a61676735b4e1ef50'
AND (
token = 'ugrd/XMJhg6RO57v6+Yi+iiJnVDhUHr7fJ8f5qBo2Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)