UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPxfm9PC1FVZsIK4peLWTWiPpvAcaTTDi5tA+5z24no='
WHERE
key_id = '0c41c49f0202df668ab1fd322601a11a1432271082bb129afdaa1dd63164d92e'
AND (
token = 'pPxfm9PC1FVZsIK4peLWTWiPpvAcaTTDi5tA+5z24no='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)