UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCdPvUUB+yb9CAU58tet3BfPVTuXOUm3hVr4mk1soTI='
WHERE
key_id = 'c004b9362818aa8a1d5ca90c5222b832bbae5ceb37f3e81f2d863e6d255762e0'
AND (
token = 'ZCdPvUUB+yb9CAU58tet3BfPVTuXOUm3hVr4mk1soTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)