UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8f5L0spThnu6fkHGM7EKBrNDanayS9RvNbjHUUh+0U='
WHERE
key_id = '34771685a36a5bc245ea4175c058fe4fad2b1727476aa89bc563a34cee92eeca'
AND (
token = 'N8f5L0spThnu6fkHGM7EKBrNDanayS9RvNbjHUUh+0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)