UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnlj+ttRd38/43riATSpt1tH0fvBXcdHpHVwxO6O4Dc='
WHERE
key_id = '1171e2dc54ec63298ad9dcb6233afa71b72f2eff519a5e4df81e4694045c29da'
AND (
token = 'pnlj+ttRd38/43riATSpt1tH0fvBXcdHpHVwxO6O4Dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)