UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGVYKCD/HlivOa5oEhU3k7RGB20I33xAt67dckDwulw='
WHERE
key_id = '00bb47c9eacfbc0672a1bd7c481bdbaede1c85b115beccf3f1bdb9a77b186a5c'
AND (
token = 'SGVYKCD/HlivOa5oEhU3k7RGB20I33xAt67dckDwulw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)