UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XP+mYzvgjjCC8MpxGs4r+9p5kFaZ88KzJ4b3E4cYFs='
WHERE
key_id = 'f5238d4aeb9182782619596d55bb89468412296d319d5355075c657eafd86345'
AND (
token = '6XP+mYzvgjjCC8MpxGs4r+9p5kFaZ88KzJ4b3E4cYFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)