UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MzUxjdWwaWAVnHL+ZfTKDiLadOQOM8d59Qsrvt19zRI='
WHERE
key_id = 'cd2c42d053247d502a1da3f1d3806b6e2e9835829b7dbec0c1bb7bc5edf26739'
AND (
token = 'MzUxjdWwaWAVnHL+ZfTKDiLadOQOM8d59Qsrvt19zRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)