UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+aA94VOHREkjpfol4nl1Pvi37096nZRU1nRGxZO1OY='
WHERE
key_id = '7e932b7f420cf887b63584763d96fd637e602f432bf828aa22ca7a654a9d03ff'
AND (
token = 'p+aA94VOHREkjpfol4nl1Pvi37096nZRU1nRGxZO1OY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)