UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXmh4zL1SFOWI3stSHHLBGkc8Rw+RmRBiAgwoh4SeZg='
WHERE
key_id = 'fff84c54883493fe364bf69d785d2ffd1c94cb24c0247c878c9b86447ed42234'
AND (
token = 'gXmh4zL1SFOWI3stSHHLBGkc8Rw+RmRBiAgwoh4SeZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)