UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f+YMEMuKgeuTVLcl9wHyFwx4JhJ42kC/P6gSFzV1SZg='
WHERE
key_id = '8bc802ed71f3dd00a2478ff380c969e3501faf10e3bd41e4c6755012186022ea'
AND (
token = 'f+YMEMuKgeuTVLcl9wHyFwx4JhJ42kC/P6gSFzV1SZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)