UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5WQiloptaeL/fFoJBeQrQ3ja5iLAAJBIwtqRNH29zHE='
WHERE
key_id = 'c8340625d5a60e18b00d8ada04201711c37443db75d6acc2fb6d7f32cf719c11'
AND (
token = '5WQiloptaeL/fFoJBeQrQ3ja5iLAAJBIwtqRNH29zHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)