UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tysouGm9mdNDaHlrlPJykvYAx3TVjNVd0gFjJA9hPh4='
WHERE
key_id = '80042f57f70057aafe154b1848e18e16d827128a2a87de5c4c1a5a925ad215b6'
AND (
token = 'tysouGm9mdNDaHlrlPJykvYAx3TVjNVd0gFjJA9hPh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)